-
Re: Pulling Averages from a Report to another sheet (Current / Prior month formula)
The COLLECT() function would essentially bucket your data into the same categories as the report does, and then changing the function from AVG() to SUM() etc could replicate the summary metrics shown…1 · -
Re: Pulling Averages from a Report to another sheet (Current / Prior month formula)
I don't believe you would be ale to pull the summary metrics from a report, but you could replicate the reports values using a formula (apologies if this is not what you want). In your final sheet wh…1 · -
Re: Cross-Sheet MATCH INDEX ERRORS
@heyjay Thank you thank you.... I wonder why that makes such a difference for a 1-dim array/column of data, and the erroneous return values were gathered from the void I guess :p - thank you again!1 ·